Análise descritiva - Internation Bank Data

Dataset statistics

Number of variables	18
Number of observations	8950
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.2 MiB
Average record size in memory	144.0 B

Variable types

Categorical	1
Numeric	17

Alerts

`cust_id` has a high cardinality: 8950 distinct values	High cardinality
`balance` is highly correlated with `balance_frequency` and 4 other fields	High correlation
`balance_frequency` is highly correlated with `balance`	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 5 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 2 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 3 other fields	High correlation
`cash_advance` is highly correlated with `balance` and 2 other fields	High correlation
`purchases_frequency` is highly correlated with `purchases` and 3 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `purchases` and 2 other fields	High correlation
`purchases_installments_frequency` is highly correlated with `purchases` and 3 other fields	High correlation
`cash_advance_frequency` is highly correlated with `balance` and 2 other fields	High correlation
`cash_advance_trx` is highly correlated with `balance` and 2 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 5 other fields	High correlation
`minimum_payments` is highly correlated with `balance`	High correlation
`balance` is highly correlated with `credit_limit`	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 3 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 3 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 2 other fields	High correlation
`cash_advance` is highly correlated with `cash_advance_frequency` and 1 other fields	High correlation
`purchases_frequency` is highly correlated with `oneoff_purchases_frequency` and 2 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `oneoff_purchases` and 2 other fields	High correlation
`purchases_installments_frequency` is highly correlated with `installments_purchases` and 2 other fields	High correlation
`cash_advance_frequency` is highly correlated with `cash_advance` and 1 other fields	High correlation
`cash_advance_trx` is highly correlated with `cash_advance` and 1 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 5 other fields	High correlation
`credit_limit` is highly correlated with `balance`	High correlation
`payments` is highly correlated with `purchases` and 1 other fields	High correlation
`balance` is highly correlated with `minimum_payments`	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 4 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 1 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 3 other fields	High correlation
`cash_advance` is highly correlated with `cash_advance_frequency` and 1 other fields	High correlation
`purchases_frequency` is highly correlated with `purchases` and 3 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `purchases` and 1 other fields	High correlation
`purchases_installments_frequency` is highly correlated with `installments_purchases` and 2 other fields	High correlation
`cash_advance_frequency` is highly correlated with `cash_advance` and 1 other fields	High correlation
`cash_advance_trx` is highly correlated with `cash_advance` and 1 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 3 other fields	High correlation
`minimum_payments` is highly correlated with `balance`	High correlation
`balance` is highly correlated with `credit_limit`	High correlation
`purchases` is highly correlated with `oneoff_purchases` and 4 other fields	High correlation
`oneoff_purchases` is highly correlated with `purchases` and 2 other fields	High correlation
`installments_purchases` is highly correlated with `purchases` and 1 other fields	High correlation
`cash_advance` is highly correlated with `cash_advance_trx` and 1 other fields	High correlation
`purchases_frequency` is highly correlated with `oneoff_purchases_frequency` and 1 other fields	High correlation
`oneoff_purchases_frequency` is highly correlated with `purchases_frequency`	High correlation
`purchases_installments_frequency` is highly correlated with `purchases_frequency`	High correlation
`cash_advance_frequency` is highly correlated with `cash_advance_trx`	High correlation
`cash_advance_trx` is highly correlated with `cash_advance` and 1 other fields	High correlation
`purchases_trx` is highly correlated with `purchases` and 3 other fields	High correlation
`credit_limit` is highly correlated with `balance` and 2 other fields	High correlation
`payments` is highly correlated with `purchases` and 4 other fields	High correlation
`cust_id` is uniformly distributed	Uniform
`cust_id` has unique values	Unique
`purchases` has 2044 (22.8%) zeros	Zeros
`oneoff_purchases` has 4302 (48.1%) zeros	Zeros
`installments_purchases` has 3916 (43.8%) zeros	Zeros
`cash_advance` has 4628 (51.7%) zeros	Zeros
`purchases_frequency` has 2043 (22.8%) zeros	Zeros
`oneoff_purchases_frequency` has 4302 (48.1%) zeros	Zeros
`purchases_installments_frequency` has 3915 (43.7%) zeros	Zeros
`cash_advance_frequency` has 4628 (51.7%) zeros	Zeros
`cash_advance_trx` has 4628 (51.7%) zeros	Zeros
`purchases_trx` has 2044 (22.8%) zeros	Zeros
`payments` has 240 (2.7%) zeros	Zeros
`prc_full_payment` has 5903 (66.0%) zeros	Zeros

Reproduction

Analysis started	2021-10-31 13:48:46.185118
Analysis finished	2021-10-31 13:51:34.912147
Duration	2 minutes and 48.73 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

cust_id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	70.0 KiB

C10001	1
C16135	1
C16129	1
C16130	1
C16131	1
Other values (8945)	8945

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8950 ?
Unique (%)	100.0%

Sample

1st row	C10001
2nd row	C10002
3rd row	C10003
4th row	C10004
5th row	C10005

Common Values

Value	Count	Frequency (%)
C10001	1	< 0.1%
C16135	1	< 0.1%
C16129	1	< 0.1%
C16130	1	< 0.1%
C16131	1	< 0.1%
C16132	1	< 0.1%
C16133	1	< 0.1%
C16134	1	< 0.1%
C16136	1	< 0.1%
C16144	1	< 0.1%
Other values (8940)	8940	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c10001	1	< 0.1%
c10011	1	< 0.1%
c10017	1	< 0.1%
c10016	1	< 0.1%
c10015	1	< 0.1%
c10014	1	< 0.1%
c10013	1	< 0.1%
c10012	1	< 0.1%
c10010	1	< 0.1%
c10034	1	< 0.1%
Other values (8940)	8940	99.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

balance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8871
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1564.474828

Minimum	0
Maximum	19043.13856
Zeros	80
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	8.81451835
Q1	128.2819155
median	873.385231
Q3	2054.140036
95-th percentile	5909.111808
Maximum	19043.13856
Range	19043.13856
Interquartile range (IQR)	1925.85812

Descriptive statistics

Standard deviation	2081.531879
Coefficient of variation (CV)	1.330498799
Kurtosis	7.6747513
Mean	1564.474828
Median Absolute Deviation (MAD)	799.865197
Skewness	2.393386043
Sum	14002049.71
Variance	4332774.965
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	80	0.9%
40.900749	1	< 0.1%
1213.551338	1	< 0.1%
1253.188317	1	< 0.1%
5058.299635	1	< 0.1%
296.905944	1	< 0.1%
1084.652647	1	< 0.1%
237.198442	1	< 0.1%
1636.518315	1	< 0.1%
468.851415	1	< 0.1%
Other values (8861)	8861	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80	0.9%
0.000199	1	< 0.1%
0.001146	1	< 0.1%
0.001214	1	< 0.1%
0.001289	1	< 0.1%
0.004816	1	< 0.1%
0.006651	1	< 0.1%
0.009684	1	< 0.1%
0.01968	1	< 0.1%
0.021102	1	< 0.1%

Value	Count	Frequency (%)
19043.13856	1	< 0.1%
18495.55855	1	< 0.1%
16304.88925	1	< 0.1%
16259.44857	1	< 0.1%
16115.5964	1	< 0.1%
15532.33972	1	< 0.1%
15258.2259	1	< 0.1%
15244.74865	1	< 0.1%
15155.53286	1	< 0.1%
14581.45914	1	< 0.1%

balance_frequency
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	43
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.8772707256

Minimum	0
Maximum	1
Zeros	80
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.272727
Q1	0.888889
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.111111

Descriptive statistics

Standard deviation	0.2369040027
Coefficient of variation (CV)	0.2700466296
Kurtosis	3.092369622
Mean	0.8772707256
Median Absolute Deviation (MAD)	0
Skewness	-2.023265519
Sum	7851.572994
Variance	0.05612350649
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
1	6211	69.4%
0.909091	410	4.6%
0.818182	278	3.1%
0.727273	223	2.5%
0.545455	219	2.4%
0.636364	209	2.3%
0.454545	172	1.9%
0.363636	170	1.9%
0.272727	151	1.7%
0.181818	146	1.6%
Other values (33)	761	8.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80	0.9%
0.090909	67	0.7%
0.1	8	0.1%
0.111111	5	0.1%
0.125	9	0.1%
0.142857	7	0.1%
0.166667	7	0.1%
0.181818	146	1.6%
0.2	9	0.1%
0.222222	5	0.1%

Value	Count	Frequency (%)
1	6211	69.4%
0.909091	410	4.6%
0.9	55	0.6%
0.888889	53	0.6%
0.875	57	0.6%
0.857143	51	0.6%
0.833333	60	0.7%
0.818182	278	3.1%
0.8	20	0.2%
0.777778	22	0.2%

purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	6203
Distinct (%)	69.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1003.204834

Minimum	0
Maximum	49039.57
Zeros	2044
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	39.635
median	361.28
Q3	1110.13
95-th percentile	3998.6195
Maximum	49039.57
Range	49039.57
Interquartile range (IQR)	1070.495

Descriptive statistics

Standard deviation	2136.634782
Coefficient of variation (CV)	2.129809098
Kurtosis	111.3887709
Mean	1003.204834
Median Absolute Deviation (MAD)	361.28
Skewness	8.144269065
Sum	8978683.26
Variance	4565208.191
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2044	22.8%
45.65	27	0.3%
60	16	0.2%
150	16	0.2%
300	13	0.1%
200	13	0.1%
100	13	0.1%
450	12	0.1%
50	10	0.1%
600	10	0.1%
Other values (6193)	6776	75.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2044	22.8%
0.01	4	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
0.7	1	< 0.1%
1	2	< 0.1%
1.4	1	< 0.1%
2	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%

Value	Count	Frequency (%)
49039.57	1	< 0.1%
41050.4	1	< 0.1%
40040.71	1	< 0.1%
38902.71	1	< 0.1%
35131.16	1	< 0.1%
32539.78	1	< 0.1%
31299.35	1	< 0.1%
27957.68	1	< 0.1%
27790.42	1	< 0.1%
26784.62	1	< 0.1%

oneoff_purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4014
Distinct (%)	44.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	592.4373709

Minimum	0
Maximum	40761.25
Zeros	4302
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	38
Q3	577.405
95-th percentile	2671.094
Maximum	40761.25
Range	40761.25
Interquartile range (IQR)	577.405

Descriptive statistics

Standard deviation	1659.887917
Coefficient of variation (CV)	2.801794753
Kurtosis	164.187572
Mean	592.4373709
Median Absolute Deviation (MAD)	38
Skewness	10.04508288
Sum	5302314.47
Variance	2755227.898
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4302	48.1%
45.65	46	0.5%
50	17	0.2%
200	15	0.2%
60	13	0.1%
100	13	0.1%
150	12	0.1%
70	12	0.1%
1000	12	0.1%
250	11	0.1%
Other values (4004)	4497	50.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4302	48.1%
0.01	7	0.1%
0.02	2	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
0.7	1	< 0.1%
1	4	< 0.1%
1.4	2	< 0.1%
2	1	< 0.1%
4.99	1	< 0.1%

Value	Count	Frequency (%)
40761.25	1	< 0.1%
40624.06	1	< 0.1%
34087.73	1	< 0.1%
33803.84	1	< 0.1%
26547.43	1	< 0.1%
26514.32	1	< 0.1%
25122.77	1	< 0.1%
24543.52	1	< 0.1%
23032.97	1	< 0.1%
22257.39	1	< 0.1%

installments_purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4452
Distinct (%)	49.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	411.0676447

Minimum	0
Maximum	22500
Zeros	3916
Zeros (%)	43.8%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	89
Q3	468.6375
95-th percentile	1750.0875
Maximum	22500
Range	22500
Interquartile range (IQR)	468.6375

Descriptive statistics

Standard deviation	904.3381152
Coefficient of variation (CV)	2.199973963
Kurtosis	96.57517753
Mean	411.0676447
Median Absolute Deviation (MAD)	89
Skewness	7.299119909
Sum	3679055.42
Variance	817827.4266
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3916	43.8%
300	14	0.2%
200	14	0.2%
100	14	0.2%
150	12	0.1%
125	11	0.1%
75	9	0.1%
350	8	0.1%
450	8	0.1%
500	8	0.1%
Other values (4442)	4936	55.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3916	43.8%
1.95	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
6.33	1	< 0.1%
7.26	1	< 0.1%
7.67	1	< 0.1%
9.28	1	< 0.1%
9.58	1	< 0.1%
9.65	1	< 0.1%

Value	Count	Frequency (%)
22500	1	< 0.1%
15497.19	1	< 0.1%
14686.1	1	< 0.1%
13184.43	1	< 0.1%
12738.47	1	< 0.1%
12560.85	1	< 0.1%
12541	1	< 0.1%
12375	1	< 0.1%
12235.05	1	< 0.1%
12128.94	1	< 0.1%

cash_advance
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	4323
Distinct (%)	48.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	978.8711125

Minimum	0
Maximum	47137.21176
Zeros	4628
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1113.821139
95-th percentile	4647.169122
Maximum	47137.21176
Range	47137.21176
Interquartile range (IQR)	1113.821139

Descriptive statistics

Standard deviation	2097.163877
Coefficient of variation (CV)	2.142431062
Kurtosis	52.89943411
Mean	978.8711125
Median Absolute Deviation (MAD)	0
Skewness	5.166609074
Sum	8760896.457
Variance	4398096.325
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
495.425832	1	< 0.1%
1486.243293	1	< 0.1%
855.232779	1	< 0.1%
3767.104707	1	< 0.1%
291.608512	1	< 0.1%
38.690552	1	< 0.1%
521.664369	1	< 0.1%
1974.202963	1	< 0.1%
2462.100789	1	< 0.1%
Other values (4313)	4313	48.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4628	51.7%
14.222216	1	< 0.1%
18.042768	1	< 0.1%
18.117967	1	< 0.1%
18.123413	1	< 0.1%
18.126683	1	< 0.1%
18.149946	1	< 0.1%
18.204577	1	< 0.1%
18.240626	1	< 0.1%
18.280043	1	< 0.1%

Value	Count	Frequency (%)
47137.21176	1	< 0.1%
29282.10915	1	< 0.1%
27296.48576	1	< 0.1%
26268.69989	1	< 0.1%
26194.04954	1	< 0.1%
23130.82106	1	< 0.1%
22665.7785	1	< 0.1%
21943.84942	1	< 0.1%
20712.67008	1	< 0.1%
20277.33112	1	< 0.1%

purchases_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4903505484

Minimum	0
Maximum	1
Zeros	2043
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.083333
median	0.5
Q3	0.916667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.833334

Descriptive statistics

Standard deviation	0.4013707474
Coefficient of variation (CV)	0.8185383879
Kurtosis	-1.638630948
Mean	0.4903505484
Median Absolute Deviation (MAD)	0.416667
Skewness	0.06016423586
Sum	4388.637408
Variance	0.1610984768
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	2178	24.3%
0	2043	22.8%
0.083333	677	7.6%
0.916667	396	4.4%
0.5	395	4.4%
0.166667	392	4.4%
0.833333	373	4.2%
0.333333	367	4.1%
0.25	345	3.9%
0.583333	316	3.5%
Other values (37)	1468	16.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2043	22.8%
0.083333	677	7.6%
0.090909	43	0.5%
0.1	27	0.3%
0.111111	18	0.2%
0.125	32	0.4%
0.142857	26	0.3%
0.166667	392	4.4%
0.181818	16	0.2%
0.2	19	0.2%

Value	Count	Frequency (%)
1	2178	24.3%
0.916667	396	4.4%
0.909091	28	0.3%
0.9	24	0.3%
0.888889	18	0.2%
0.875	26	0.3%
0.857143	25	0.3%
0.833333	373	4.2%
0.818182	21	0.2%
0.8	9	0.1%

oneoff_purchases_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2024576836

Minimum	0
Maximum	1
Zeros	4302
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.083333
Q3	0.3
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	0.2983360652
Coefficient of variation (CV)	1.473572452
Kurtosis	1.161845601
Mean	0.2024576836
Median Absolute Deviation (MAD)	0.083333
Skewness	1.535612784
Sum	1811.996268
Variance	0.08900440779
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	4302	48.1%
0.083333	1104	12.3%
0.166667	592	6.6%
1	481	5.4%
0.25	418	4.7%
0.333333	355	4.0%
0.416667	244	2.7%
0.5	235	2.6%
0.583333	197	2.2%
0.666667	167	1.9%
Other values (37)	855	9.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4302	48.1%
0.083333	1104	12.3%
0.090909	56	0.6%
0.1	39	0.4%
0.111111	26	0.3%
0.125	41	0.5%
0.142857	37	0.4%
0.166667	592	6.6%
0.181818	34	0.4%
0.2	27	0.3%

Value	Count	Frequency (%)
1	481	5.4%
0.916667	151	1.7%
0.909091	4	< 0.1%
0.9	1	< 0.1%
0.888889	2	< 0.1%
0.875	6	0.1%
0.857143	1	< 0.1%
0.833333	120	1.3%
0.818182	10	0.1%
0.8	4	< 0.1%

purchases_installments_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3644373416

Minimum	0
Maximum	1
Zeros	3915
Zeros (%)	43.7%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.166667
Q3	0.75
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.3974477797
Coefficient of variation (CV)	1.090579187
Kurtosis	-1.398632185
Mean	0.3644373416
Median Absolute Deviation (MAD)	0.166667
Skewness	0.509201165
Sum	3261.714207
Variance	0.1579647376
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	3915	43.7%
1	1331	14.9%
0.416667	388	4.3%
0.916667	345	3.9%
0.833333	311	3.5%
0.5	310	3.5%
0.166667	305	3.4%
0.666667	292	3.3%
0.75	291	3.3%
0.083333	275	3.1%
Other values (37)	1187	13.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3915	43.7%
0.083333	275	3.1%
0.090909	12	0.1%
0.1	6	0.1%
0.111111	9	0.1%
0.125	5	0.1%
0.142857	6	0.1%
0.166667	305	3.4%
0.181818	14	0.2%
0.2	9	0.1%

Value	Count	Frequency (%)
1	1331	14.9%
0.916667	345	3.9%
0.909091	25	0.3%
0.9	19	0.2%
0.888889	28	0.3%
0.875	28	0.3%
0.857143	30	0.3%
0.833333	311	3.5%
0.818182	21	0.2%
0.8	18	0.2%

cash_advance_frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	54
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1351442003

Minimum	0
Maximum	1.5
Zeros	4628
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.222222
95-th percentile	0.583333
Maximum	1.5
Range	1.5
Interquartile range (IQR)	0.222222

Descriptive statistics

Standard deviation	0.2001213881
Coefficient of variation (CV)	1.480798937
Kurtosis	3.334734328
Mean	0.1351442003
Median Absolute Deviation (MAD)	0
Skewness	1.828686266
Sum	1209.540593
Variance	0.04004856999
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
0.083333	1021	11.4%
0.166667	759	8.5%
0.25	578	6.5%
0.333333	439	4.9%
0.416667	273	3.1%
0.5	215	2.4%
0.583333	142	1.6%
0.666667	125	1.4%
0.090909	70	0.8%
Other values (44)	700	7.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4628	51.7%
0.083333	1021	11.4%
0.090909	70	0.8%
0.1	39	0.4%
0.111111	29	0.3%
0.125	47	0.5%
0.142857	49	0.5%
0.166667	759	8.5%
0.181818	42	0.5%
0.2	21	0.2%

Value	Count	Frequency (%)
1.5	1	< 0.1%
1.25	1	< 0.1%
1.166667	2	< 0.1%
1.142857	1	< 0.1%
1.125	1	< 0.1%
1.1	1	< 0.1%
1.090909	1	< 0.1%
1	25	0.3%
0.916667	27	0.3%
0.909091	3	< 0.1%

cash_advance_trx
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	65
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.248826816

Minimum	0
Maximum	123
Zeros	4628
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	15
Maximum	123
Range	123
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	6.824646744
Coefficient of variation (CV)	2.100649598
Kurtosis	61.64686248
Mean	3.248826816
Median Absolute Deviation (MAD)	0
Skewness	5.721298203
Sum	29077
Variance	46.57580318
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
1	887	9.9%
2	620	6.9%
3	436	4.9%
4	384	4.3%
5	308	3.4%
6	246	2.7%
7	205	2.3%
8	171	1.9%
10	150	1.7%
Other values (55)	915	10.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4628	51.7%
1	887	9.9%
2	620	6.9%
3	436	4.9%
4	384	4.3%
5	308	3.4%
6	246	2.7%
7	205	2.3%
8	171	1.9%
9	111	1.2%

Value	Count	Frequency (%)
123	3	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
93	1	< 0.1%
80	1	< 0.1%
71	1	< 0.1%
69	1	< 0.1%
63	1	< 0.1%
62	3	< 0.1%
61	1	< 0.1%

purchases_trx
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	173
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.7098324

Minimum	0
Maximum	358
Zeros	2044
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	17
95-th percentile	57
Maximum	358
Range	358
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	24.85764911
Coefficient of variation (CV)	1.689866236
Kurtosis	34.79310026
Mean	14.7098324
Median Absolute Deviation (MAD)	7
Skewness	4.630655266
Sum	131653
Variance	617.9027193
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2044	22.8%
1	667	7.5%
12	570	6.4%
2	379	4.2%
6	352	3.9%
3	314	3.5%
4	285	3.2%
7	275	3.1%
5	267	3.0%
8	267	3.0%
Other values (163)	3530	39.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2044	22.8%
1	667	7.5%
2	379	4.2%
3	314	3.5%
4	285	3.2%
5	267	3.0%
6	352	3.9%
7	275	3.1%
8	267	3.0%
9	248	2.8%

Value	Count	Frequency (%)
358	1	< 0.1%
347	1	< 0.1%
344	1	< 0.1%
309	1	< 0.1%
308	1	< 0.1%
298	1	< 0.1%
274	1	< 0.1%
273	1	< 0.1%
254	1	< 0.1%
248	2	< 0.1%

credit_limit
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	206
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4494.44945

Minimum	50
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	50
5-th percentile	1000
Q1	1600
median	3000
Q3	6500
95-th percentile	12000
Maximum	30000
Range	29950
Interquartile range (IQR)	4900

Descriptive statistics

Standard deviation	3638.612411
Coefficient of variation (CV)	0.8095791156
Kurtosis	2.837308005
Mean	4494.44945
Median Absolute Deviation (MAD)	1800
Skewness	1.522549038
Sum	40225322.58
Variance	13239500.28
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3000	784	8.8%
1500	722	8.1%
1200	621	6.9%
1000	614	6.9%
2500	612	6.8%
4000	506	5.7%
6000	463	5.2%
5000	389	4.3%
2000	371	4.1%
7500	277	3.1%
Other values (196)	3591	40.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50	1	< 0.1%
150	5	0.1%
200	3	< 0.1%
300	14	0.2%
400	3	< 0.1%
450	6	0.1%
500	121	1.4%
600	21	0.2%
650	1	< 0.1%
700	20	0.2%

Value	Count	Frequency (%)
30000	2	< 0.1%
28000	1	< 0.1%
25000	1	< 0.1%
23000	2	< 0.1%
22500	1	< 0.1%
22000	1	< 0.1%
21500	2	< 0.1%
21000	2	< 0.1%
20500	1	< 0.1%
20000	10	0.1%

payments
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	8711
Distinct (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1733.143852

Minimum	0
Maximum	50721.48336
Zeros	240
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	89.98892395
Q1	383.276166
median	856.901546
Q3	1901.134317
95-th percentile	6082.090595
Maximum	50721.48336
Range	50721.48336
Interquartile range (IQR)	1517.858151

Descriptive statistics

Standard deviation	2895.063757
Coefficient of variation (CV)	1.670411693
Kurtosis	54.77073581
Mean	1733.143852
Median Absolute Deviation (MAD)	581.3514605
Skewness	5.907619794
Sum	15511637.48
Variance	8381394.157
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	240	2.7%
201.802084	1	< 0.1%
398.316441	1	< 0.1%
826.036748	1	< 0.1%
2571.573214	1	< 0.1%
1903.279643	1	< 0.1%
454.888506	1	< 0.1%
956.028747	1	< 0.1%
4560.77572	1	< 0.1%
1825.349955	1	< 0.1%
Other values (8701)	8701	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	240	2.7%
0.049513	1	< 0.1%
0.056466	1	< 0.1%
2.389583	1	< 0.1%
3.500505	1	< 0.1%
4.523555	1	< 0.1%
4.841543	1	< 0.1%
5.070726	1	< 0.1%
9.040017	1	< 0.1%
9.533313	1	< 0.1%

Value	Count	Frequency (%)
50721.48336	1	< 0.1%
46930.59824	1	< 0.1%
40627.59524	1	< 0.1%
39461.9658	1	< 0.1%
39048.59762	1	< 0.1%
36066.75068	1	< 0.1%
35843.62593	1	< 0.1%
34107.07499	1	< 0.1%
33994.72785	1	< 0.1%
33486.31044	1	< 0.1%

minimum_payments
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	8637
Distinct (%)	96.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	864.2065423

Minimum	0.019163
Maximum	76406.20752
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0.019163
5-th percentile	74.6441173
Q1	170.8576542
median	335.6283125
Q3	864.2065423
95-th percentile	2719.566935
Maximum	76406.20752
Range	76406.18836
Interquartile range (IQR)	693.3488881

Descriptive statistics

Standard deviation	2330.588021
Coefficient of variation (CV)	2.696795161
Kurtosis	294.3843928
Mean	864.2065423
Median Absolute Deviation (MAD)	211.02137
Skewness	13.86735726
Sum	7734648.554
Variance	5431640.525
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
864.2065423	313	3.5%
299.351881	2	< 0.1%
150.317143	1	< 0.1%
271.528169	1	< 0.1%
6404.855484	1	< 0.1%
616.862544	1	< 0.1%
211.984193	1	< 0.1%
324.954747	1	< 0.1%
1600.26917	1	< 0.1%
277.546713	1	< 0.1%
Other values (8627)	8627	96.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.019163	1	< 0.1%
0.037744	1	< 0.1%
0.05588	1	< 0.1%
0.059481	1	< 0.1%
0.117036	1	< 0.1%
0.261984	1	< 0.1%
0.311953	1	< 0.1%
0.319475	1	< 0.1%
1.113027	1	< 0.1%
1.334075	1	< 0.1%

Value	Count	Frequency (%)
76406.20752	1	< 0.1%
61031.6186	1	< 0.1%
56370.04117	1	< 0.1%
50260.75947	1	< 0.1%
43132.72823	1	< 0.1%
42629.55117	1	< 0.1%
38512.12477	1	< 0.1%
31871.36379	1	< 0.1%
30528.4324	1	< 0.1%
29019.80288	1	< 0.1%

prc_full_payment
Real number (ℝ_≥0)

ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1537146485

Minimum	0
Maximum	1
Zeros	5903
Zeros (%)	66.0%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.142857
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.142857

Descriptive statistics

Standard deviation	0.2924991962
Coefficient of variation (CV)	1.902871321
Kurtosis	2.432395301
Mean	0.1537146485
Median Absolute Deviation (MAD)	0
Skewness	1.942819941
Sum	1375.746104
Variance	0.0855557798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	5903	66.0%
1	488	5.5%
0.083333	426	4.8%
0.166667	166	1.9%
0.5	156	1.7%
0.25	156	1.7%
0.090909	153	1.7%
0.333333	134	1.5%
0.1	94	1.1%
0.2	83	0.9%
Other values (37)	1191	13.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5903	66.0%
0.083333	426	4.8%
0.090909	153	1.7%
0.1	94	1.1%
0.111111	61	0.7%
0.125	52	0.6%
0.142857	54	0.6%
0.166667	166	1.9%
0.181818	75	0.8%
0.2	83	0.9%

Value	Count	Frequency (%)
1	488	5.5%
0.916667	77	0.9%
0.909091	19	0.2%
0.9	16	0.2%
0.888889	12	0.1%
0.875	18	0.2%
0.857143	12	0.1%
0.833333	63	0.7%
0.818182	17	0.2%
0.8	33	0.4%

tenure
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.51731844

Minimum	6
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	70.0 KiB

Quantile statistics

Minimum	6
5-th percentile	8
Q1	12
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.338330769
Coefficient of variation (CV)	0.1162015947
Kurtosis	7.694823186
Mean	11.51731844
Median Absolute Deviation (MAD)	0
Skewness	-2.943017288
Sum	103080
Variance	1.791129248
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
12	7584	84.7%
11	365	4.1%
10	236	2.6%
6	204	2.3%
8	196	2.2%
7	190	2.1%
9	175	2.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	204	2.3%
7	190	2.1%
8	196	2.2%
9	175	2.0%
10	236	2.6%
11	365	4.1%
12	7584	84.7%

Value	Count	Frequency (%)
12	7584	84.7%
11	365	4.1%
10	236	2.6%
9	175	2.0%
8	196	2.2%
7	190	2.1%
6	204	2.3%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	cust_id	balance	balance_frequency	purchases	oneoff_purchases	installments_purchases	cash_advance	purchases_frequency	oneoff_purchases_frequency	purchases_installments_frequency	cash_advance_frequency	cash_advance_trx	purchases_trx	credit_limit	payments	minimum_payments	prc_full_payment	tenure
0	C10001	40.90	0.82	95.40	0.00	95.40	0.00	0.17	0.00	0.08	0.00	0	2	1000.00	201.80	139.51	0.00	12
1	C10002	3202.47	0.91	0.00	0.00	0.00	6442.95	0.00	0.00	0.00	0.25	4	0	7000.00	4103.03	1072.34	0.22	12
2	C10003	2495.15	1.00	773.17	773.17	0.00	0.00	1.00	1.00	0.00	0.00	0	12	7500.00	622.07	627.28	0.00	12
3	C10004	1666.67	0.64	1499.00	1499.00	0.00	205.79	0.08	0.08	0.00	0.08	1	1	7500.00	0.00	864.21	0.00	12
4	C10005	817.71	1.00	16.00	16.00	0.00	0.00	0.08	0.08	0.00	0.00	0	1	1200.00	678.33	244.79	0.00	12
5	C10006	1809.83	1.00	1333.28	0.00	1333.28	0.00	0.67	0.00	0.58	0.00	0	8	1800.00	1400.06	2407.25	0.00	12
6	C10007	627.26	1.00	7091.01	6402.63	688.38	0.00	1.00	1.00	1.00	0.00	0	64	13500.00	6354.31	198.07	1.00	12
7	C10008	1823.65	1.00	436.20	0.00	436.20	0.00	1.00	0.00	1.00	0.00	0	12	2300.00	679.07	532.03	0.00	12
8	C10009	1014.93	1.00	861.49	661.49	200.00	0.00	0.33	0.08	0.25	0.00	0	5	7000.00	688.28	311.96	0.00	12
9	C10010	152.23	0.55	1281.60	1281.60	0.00	0.00	0.17	0.17	0.00	0.00	0	3	11000.00	1164.77	100.30	0.00	12

Last rows

	cust_id	balance	balance_frequency	purchases	oneoff_purchases	installments_purchases	cash_advance	purchases_frequency	oneoff_purchases_frequency	purchases_installments_frequency	cash_advance_frequency	cash_advance_trx	purchases_trx	credit_limit	payments	minimum_payments	prc_full_payment	tenure
8940	C19181	130.84	1.00	591.24	0.00	591.24	0.00	1.00	0.00	0.83	0.00	0	6	1000.00	475.52	82.77	1.00	6
8941	C19182	5967.48	0.83	214.55	0.00	214.55	8555.41	0.83	0.00	0.67	0.67	13	5	9000.00	966.20	861.95	0.00	6
8942	C19183	40.83	1.00	113.28	0.00	113.28	0.00	1.00	0.00	0.83	0.00	0	6	1000.00	94.49	86.28	0.25	6
8943	C19184	5.87	0.50	20.90	20.90	0.00	0.00	0.17	0.17	0.00	0.00	0	1	500.00	58.64	43.47	0.00	6
8944	C19185	193.57	0.83	1012.73	1012.73	0.00	0.00	0.33	0.33	0.00	0.00	0	2	4000.00	0.00	864.21	0.00	6
8945	C19186	28.49	1.00	291.12	0.00	291.12	0.00	1.00	0.00	0.83	0.00	0	6	1000.00	325.59	48.89	0.50	6
8946	C19187	19.18	1.00	300.00	0.00	300.00	0.00	1.00	0.00	0.83	0.00	0	6	1000.00	275.86	864.21	0.00	6
8947	C19188	23.40	0.83	144.40	0.00	144.40	0.00	0.83	0.00	0.67	0.00	0	5	1000.00	81.27	82.42	0.25	6
8948	C19189	13.46	0.83	0.00	0.00	0.00	36.56	0.00	0.00	0.00	0.17	2	0	500.00	52.55	55.76	0.25	6
8949	C19190	372.71	0.67	1093.25	1093.25	0.00	127.04	0.67	0.67	0.00	0.33	2	23	1200.00	63.17	88.29	0.00	6

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows